package br.ucb.rest.persistencia.vo;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

@Entity
@Table(name="rst_garcom")
@SequenceGenerator(name="GarcomVO.seq", sequenceName="restaurante.rst_garcom_nu_garcom_seq")
@NamedQueries({
	@NamedQuery(name="GarcomVO.recuperarPorNumero", 
		query="SELECT a FROM GarcomVO a WHERE a.numeroGarcom = :numeroGarcom "),
		
	@NamedQuery(name="GarcomVO.recuperarNome", 
		query="SELECT a.noGarcom FROM GarcomVO a " +
			"WHERE a.numeroGarcom = :numeroGarcom ")
})
public class GarcomVO implements Serializable {
	private static final long serialVersionUID = -5600896691525923831L;

	@Id
	@Column(name="nu_garcom")
	@GeneratedValue(generator="GarcomVO.seq", strategy=GenerationType.AUTO)
	private Integer nuGarcom;
	@Column(name="no_garcom", length=60)
	private String noGarcom;
	@Column(name="numero_garcom")
	private Integer numeroGarcom;
	
	public Integer getNuGarcom() {
		return nuGarcom;
	}
	public void setNuGarcom(Integer nuGarcom) {
		this.nuGarcom = nuGarcom;
	}
	public String getNoGarcom() {
		return noGarcom;
	}
	public void setNoGarcom(String noGarcom) {
		this.noGarcom = noGarcom;
	}
	public Integer getNumeroGarcom() {
		return numeroGarcom;
	}
	public void setNumeroGarcom(Integer numeroGarcom) {
		this.numeroGarcom = numeroGarcom;
	}

}
